﻿SELECT     ADDRESS + ' ' + ZIP AS FullAddress
FROM         SCORE_ACC_PROPERTIES.PROPERTIES
WHERE TRAC_ID='{0}'